use vudu

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ConsultarUniversidadRol]
AS
BEGIN
	SET NOCOUNT ON;

    SELECT u.id_Universidad, u.nombre
	FROM Universidad u
	WHERE u.id_Universidad NOT IN (SELECT r.fk_id_universidad FROM ROL r WHERE fk_id_universidad is not null);
END